<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@page import="Model_Db.DbUtil"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<style type="text/css">
	td{
		margin-left:100px;
		margin-top:100px;
		margin-right:100px;
		margin-bottom:100px;
		border:1px solid #E51094;
	}

</style>
</head>
<body>
<jsp:useBean id="b" class="Model_Db.DbUtil" ></jsp:useBean>
<% String sql="select MAX(ch_date),ch_doctorid,ch_symptom,ch_Degree_symptoms,ch_plan from t_casehistory where ch_patientid='"+request.getParameter("patient_id")+"'";

ResultSet rs=b.QuerySQL(sql);
rs.last();
%>
	<br><br><br><br>
    <table border="1" style="background-color:#C4FFC9;text-align:center;border:0.1px solid #E51094 ;" >
		<tr><td style="width:150px">日期</td><td style="width:400px">目前症状</td>
			<td style="width:100px">医师ID号</td><td style="width:150px">症状程度</td><td style="width:400px">后面医疗计划</td></tr>
		<% rs.beforeFirst();
		while(rs.next()){
		%>
		<tr>
			<td><%=rs.getString("MAX(ch_date)") %></td>
			<td><%=rs.getString("ch_symptom") %></td>
			<td><%=rs.getString("ch_doctorid") %></td>
			<td><%=rs.getString("ch_Degree_symptoms") %></td>
			<td><%=rs.getString("ch_plan") %></td>
		</tr>
		
	
		<%}%>
	</table>
</body>
</html>